﻿CREATE TABLE [dbo].[Reservas] (
    [id_reserva]         BIGINT          IDENTITY (1, 1) NOT NULL,
    [id_grupo]           BIGINT          NOT NULL,
    [id_sala]            INT             NOT NULL,
    [horario_entrada]    SMALLDATETIME   NOT NULL,
    [horario_salida]     SMALLDATETIME   NOT NULL,
    [senia]              NUMERIC (10, 2) NOT NULL,
    [saldo]              NUMERIC (10, 2) NOT NULL,
    [fecha_creacion]     SMALLDATETIME   NOT NULL,
    [fecha_modificacion] SMALLDATETIME   NULL,
    [id_estado]          INT             NOT NULL
);

